Informix 查看表结构

1. 查看表结构

SELECT c.colname[1,20], c.coltype, c.collength
FROM syscolumns c, systables t
WHERE c.tabid = t.tabid
AND t.tabname = 'xxxTable';

2. 扫描所有表字段

dbaccess -e cashbill  table.sql | grep -vE 'Database|^$|colname|SELECT|WHERE|AND|FROM' | awk   '{print $1}' |sed 's/$/,/g'|perl -lane '{printf $_} '  > ji
sed ':a;N;s/\n/ /g;ta' ji